Nic Larsen

Overview

Overview
Roles	Member
Badges	41

About Me
Not much happening here, yet.

527

Posts

2,462

Visits

11.4k

Points

Jun 26, 2018

Join Date

Mar 7, 2025

Last Active

Re: True/False IF formula not working?

Nic Larsen

11/15/23

@JWPMC 5% in a formula would be .05. Update your formula and it should work.

1 ·
Re: Formula not working for creating a score in a survey

Nic Larsen

10/25/23

Try: =IF([Is the agency's experience with local, state or fe]@row = "≤ 1 year", 1, IF([Is the agency's experience with local, state or fe]@row = "≥ 5 years", 2, 3

1 ·
Re: Need to check and uncheck a box based on a percentage being above 0 and less than 100.

Nic Larsen

09/15/23

@SmartSheet Newbie If the % complete = 100% (which is a 1 in a formula), then uncheck which is a 0 value in a checkbox column. If the % complete is greater than 0, check the box (which is a 1 value).…

1 ·
Re: Need to check and uncheck a box based on a percentage being above 0 and less than 100.

Nic Larsen

09/15/23

Try: =IF([Percent Completed]@row = 1, 0, IF([Percent Completed]@row > 0, 1))

1 ·
Re: Show approval status based on # of approvals vs. denials

Nic Larsen

08/22/23

Something like this: =IF([Approval Count]@row = 6, "Yes", IF([Denied Count]@row >= 1, "No", "Hold"))

1 ·